// sqlMap.js  sql语句
const sqlMap = {
  Stu: {
    add: 'insert into lianxi(mailbox,name,role_mg,state_mg,phone,password) values (?,?,?,?,?,?)',
    addequipment: 'insert into equipment(sensor,number,ID,data,company,username) values (?,?,?,?,?,?)',
    show: 'select * from lianxi',
    showdata1: 'select * from data1 where ID = ?',
    showequipment: 'select * from equipment',
    showone: 'select * from lianxi where name = ?',
    showoneequipment: 'select * from equipment where ID = ?',
    del: 'delete from lianxi where name = ?',
    delequipment: 'delete from equipment where ID = ?',
    update: 'update lianxi set mailbox = ?,name = ?,role_mg = ?,state_mg = ?,phone = ?,password = ? where name = ?',
    countshuliang: 'select count(*) as "count" from equipment where sensor = ?'
  }
}

module.exports = sqlMap